MATCH_LINE_BY_ID = "MATCH (l:Line {lineId: $lineId}) RETURN l"
# 可继续补充line相关Cypher语句 

GET_LINE_LIST = '''
MATCH (l:Line)
{where}
RETURN l
'''

GET_LINE_DETAIL_WORKBENCHES = '''
MATCH (l:Line {lineId: $lineId})-[:LINE_CONTAINS]->(w:WorkBench) RETURN w
'''

CREATE_LINE = '''
CREATE (l:Line {lineId: $lineId, lineName: $lineName, status: $status, describe: $describe, createdBy: $createdBy, createdAt: $createdAt, updatedBy: $updatedBy, updatedAt: $updatedAt})
RETURN l
'''

UPDATE_LINE = 'MATCH (l:Line {lineId: $lineId}) SET {set_clauses} RETURN l'

DELETE_LINE = 'MATCH (l:Line {lineId: $lineId}) DETACH DELETE l'

DELETE_LINE_WORKBENCH_REL = 'MATCH (l:Line {lineId: $lineId})-[r:LINE_CONTAINS]->() DELETE r'

CREATE_LINE_WORKBENCH_REL = 'MATCH (l:Line {lineId: $lineId}), (w:WorkBench {benchId: $benchId}) CREATE (l)-[:LINE_CONTAINS]->(w)'

GET_LINE_WORKBENCHES = 'MATCH (l:Line {lineId: $lineId})-[:LINE_CONTAINS]->(w:WorkBench) RETURN w'

CHECK_LINE_EXISTS = "MATCH (l:Line {lineId: $lineId}) RETURN l" 